Analyzing DB2 Data Sharing Performance Problems
نویسنده
چکیده
DB2 data sharing offers many advantages in the right environment, and performs very well when DB2 is properly tuned. DB2 data sharing can significantly increase capacity, it offers increased availability, and it provides a flexible operating environment. In certain environments, DB2 data sharing can dramatically improve performance of DB2 subsystems (e.g., when most data are shared and most of the shared data can fit into group buffer pools, data sharing members do not have to continually reference DASD). On the other hand, remarkably unsatisfying DB2 performance can be the result if DB2 data sharing is poorly tuned. This paper describes common problems with DB2 data sharing, and offers alternative solutions to the problems.
منابع مشابه
1 “ Sysplex / CICSplex / DB 2 Data Sharing : Assessing the Costs and Analyzing New Measurement Data
The IBM benchmarks for DB2 have shown that in a 100% data sharing environment the throughput loss is less than 17% with an additional fixed cost of 2-3% for Sysplex management. The benchmarks which we conducted in a Sysplex/CICSplex/DB2 data sharing environment yielded less than 12% overall overhead, but more importantly we can demonstrate that only those workloads with a high degree of data sh...
متن کاملDB2 Buffer Pool Tuning - Top Down or Bottom Up?
This paper addresses the goals and objectives of buffer pool tuning, and the performance data that should wave a "red flag" indicating performance problems. Available data from standard reporting facilities provides much information about performance, but does not provide the entire picture. The top down tuning approach uses DB2 data sources. The bottom up approach uses other data sources outsi...
متن کاملPerformance Analysis and Tuning for DB2 UDB
This paper is based on the Author’s experiences in performance analysis and tuning for DB2 UDB on distributed platforms. The paper is intended as an introduction to DB2 performance, particularly for those who already have a grasp of relational database concepts through products like SQL Server or Oracle. The paper compares and contrasts DB2 and Oracle, describes the primary sources of DB2 perfo...
متن کاملfAST Refresh using Mass Query Optimization
Automatic Summary Tables (ASTs), more commonly known as materialized views, are widely used to enhance query performance, particularly for aggregate queries. Such queries access a huge number of rows to retrieve aggregated summary data while performing multiple joins in the context of a typical data warehouse star schema. To keep ASTs consistent with their underlying base data, the ASTs are eit...
متن کاملMeasurement and modeling of DB2 zIIP workloads
IBM System z9 Integrated Information Processors (IBM zIIP) provide very attractive price / performance options for appropriate DB2 environments. They also add complexity to performance management and capacity planning. This paper will discuss sources of data that can be used to estimate the amount of current DB2 workload eligible for zIIP processors. Modeling techniques using that data will sho...
متن کامل